package com.hh.materialCostPrice.mapper;

import com.hh.materialCostPrice.Vo.*;
import com.hh.materialCostPrice.bean.SpareCostPrice;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author Hanh
 * @date 2023/8/9 10:18s
 */
@Mapper
public interface MaterialPriceMapper 
{
    Integer getAllMaterialCostPriceCount(QueryPageVo queryPageVo);

    List<QueryPageForFrontVo> getMatterialCostPrice(QueryPageVo queryPageVo);

    void updateSparePriceStatus(UpdateStatusVo statusVo);

    List<SpareCostPrice> countExistSparePriceByCode(AddSparePriceVo addSparePriceVo);

    void addSparePrice(AddSparePriceVo addSparePriceVo);

    void removeSparePrice(AddSparePriceVo addSparePriceVo);

    void insertExistSparePrice(SpareCostPrice spareCostPrice);

    SpareCostPrice getMatterialCostPriceById(ModifySparePriceVo modifyVo);

    List<SpareCostPrice> countExistSparePriceById(SpareCostPrice spareCostPrice);

    void removeSparePriceById(Integer id);


    void removeSparePriceByUp(SpareCostPrice spareCostPrice);

    void modifyDataById(@Param("id") Integer id,@Param("price") Double price,@Param("remark") String remark);
}
